﻿CREATE TABLE [dbo].[User] (
    [Id]            UNIQUEIDENTIFIER NOT NULL,
    [Username]      NVARCHAR (50)    NOT NULL,
    [Password]      NVARCHAR (MAX)   NOT NULL,
    [Administrator] BIT              NOT NULL,
    [FirstName]     NVARCHAR (MAX)   NULL,
    [LastName]      NVARCHAR (MAX)   NULL,
    [UserType]      TINYINT          NOT NULL,
    [Active]        BIT              NOT NULL,
    [EmailAddress]  NVARCHAR (MAX)   NULL,
    [Attributes]    NVARCHAR (MAX)   NULL
);







